MySQL(五) NOT 与 IN 操作符
IN 操作符
IN 操作符用来指定条件范围, 范围中的每个条件都可以进行匹配, 范围中的每个条件都可以进行匹配.
SELECT column_1, column_2 FROM table_name WHERE column_3 IN (1002, 1003) ORDER BY column_1;
IN 操作符与 OR 有相同的功能. 但是 IN 操作符表达的意思更加清晰, 且执行速度更快.
NOT 操作符
NOT 操作符对它后面所跟的条件取反.
SELECT column_1, column_2 FROM table_name WHERE column_3 NOT IN (1002, 1003) ORDER BY column_1;
Generated by Emacs 25.x(Org mode 8.x)
Copyright © 2014 - Pinvon - Powered by EGO